Business Analysis

DATA

The dataset spans from 2011 to 2016 and encompasses business trading activities across three countries and 31 states. With over 3000 data points encompassing information such as customer age and gender, product details, product categories, dates, and more.

Key Findings

1. Overview:

• France constitutes the majority of the orders, comprising 88% of total orders, while other countries contribute approximately 6%.
• Customer demographics reveal an even distribution of gender, with a significant presence of young adults and adults, suggesting a need for targeted marketing strategies.
• Order volumes have shown a progressive increase over time, with clear seasonality observed, potentially influenced by external factors.

2. Profit:

• The business has generated a total profit of 904k pounds, with an average profit per product sold of 193 pounds.
• Some products, such as AWC Logo caps and certain jerseys, yield negative profits, warranting further investigation into underlying causes.
• Mountain bikes emerge as the highest profit-generating products, with road bikes following closely behind.

3. Orders:

• A progressive increase in orders can be seen, expecting nearly 2000 orders annually by 2020.
• Accessories, particularly patch kits, dominate product lineup, notably in 2014 and 2016.
• Normal age distribution with female customers slightly younger; average customer age increasing suggests marketing focus shift.

Limitations:

• While our analysis provides valuable insights, it's important to acknowledge limitations such as the lack of customer-related information, which hinders the exploration of crucial metrics like customer retention rate and sentiment.

Overview

Orders

Profit